2012-05-25 - 4307 - Break Fix - SA900 Series Data and Parameter's Isuue #CrystalReportsSupport
BREAK FIX
4307 - SA900 Series Data and Parameter's Isuue
Problem Summary
SA900 Series reports with no data and invalid parameter's.
Admin Info
Purpose
|
SA900 Series reports with no data and invalid parameter's.
|
Requested by
|
Mark Harris
|
Issue Date
|
05/25/2012
|
Resolved by
|
Narendra Koraganji
|
Resolved Date
|
05/25/2012
|
Document Status
|
Complete
|
Detailed Problem Description
1. All SA900 reports are running fine but it was not fetching any data.
2. Need to work on the SA900 series reports to show the correct data in the report.
3. We are having problem with Parameters in the report and we need to fix the issue.
Solution Analysis and Recommendations
1. Need to check the Parameters order in the Crystal Report Designer as well in the BO Edge server.
2. Need to Compare the data types of the Pramaters in both Designer and in BO Edge server report.
3. Need to arrange the correct order and we need to change the data types if needed.
4. Need to analyze why data is not populating the report.
5. Need to run the report in the designer as well in the BO Edge server and compare both instances.
6. Need to update the datasource of the report and run the report in both desinger and in Edge server.
Resolution
1. Need to update the datasource in the Crystal Report using Set Datasource Location Option.
2. Need to check the Database Null option in the reports.
3. Need to run the report after updating the source in Designer as well in the BO Edge server.
4. Need to compare both instances whether they are fetching correct result.
5. Need to compare with respective BW queries.
6. Need to check the order of Parameters in the Designer and in Edge server report.
7. Need to check the data types of the parameters in the report.
8. Need to check whether we are passing correct values to the parameters.
Release Information
None